Pandas Profiling Report

Dataset statistics

Number of variables	9
Number of observations	637
Missing cells	278
Missing cells (%)	4.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	44.9 KiB
Average record size in memory	72.2 B

Variable types

Numeric	8
Categorical	1

Alerts

`Outcome` has constant value "0.0"	Constant
`Pregnancies` is highly correlated with `Age`	High correlation
`Age` is highly correlated with `Pregnancies`	High correlation
`Pregnancies` is highly correlated with `Age`	High correlation
`Age` is highly correlated with `Pregnancies`	High correlation
`Pregnancies` is highly correlated with `Age`	High correlation
`SkinThickness` is highly correlated with `Insulin` and 1 other fields	High correlation
`Insulin` is highly correlated with `SkinThickness`	High correlation
`BMI` is highly correlated with `SkinThickness`	High correlation
`Age` is highly correlated with `Pregnancies`	High correlation
`Pregnancies` has 18 (2.8%) missing values	Missing
`Glucose` has 10 (1.6%) missing values	Missing
`SkinThickness` has 12 (1.9%) missing values	Missing
`BMI` has 8 (1.3%) missing values	Missing
`DiabetesPedigreeFunction` has 12 (1.9%) missing values	Missing
`Age` has 15 (2.4%) missing values	Missing
`Outcome` has 203 (31.9%) missing values	Missing
`Pregnancies` has 90 (14.1%) zeros	Zeros

Reproduction

Analysis started	2022-09-19 19:21:02.989096
Analysis finished	2022-09-19 19:21:19.016608
Duration	16.03 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Pregnancies
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	12
Distinct (%)	1.9%
Missing	18
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	3.626817447

Minimum	0
Maximum	11
Zeros	90
Zeros (%)	14.1%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	6
95-th percentile	10
Maximum	11
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.028664255
Coefficient of variation (CV)	0.8350749104
Kurtosis	-0.5790743989
Mean	3.626817447
Median Absolute Deviation (MAD)	2
Skewness	0.6754738387
Sum	2245
Variance	9.172807169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	108	17.0%
0	90	14.1%
2	87	13.7%
3	62	9.7%
4	58	9.1%
5	48	7.5%
6	43	6.8%
7	37	5.8%
8	28	4.4%
9	26	4.1%
Other values (2)	32	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	14.1%
1	108	17.0%
2	87	13.7%
3	62	9.7%
4	58	9.1%
5	48	7.5%
6	43	6.8%
7	37	5.8%
8	28	4.4%
9	26	4.1%

Value	Count	Frequency (%)
11	10	1.6%
10	22	3.5%
9	26	4.1%
8	28	4.4%
7	37	5.8%
6	43	6.8%
5	48	7.5%
4	58	9.1%
3	62	9.7%
2	87	13.7%

Glucose
Real number (ℝ_≥0)

MISSING

Distinct	124
Distinct (%)	19.8%
Missing	10
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	116.4808176

Minimum	44
Maximum	191
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	44
5-th percentile	79
Q1	97
median	112
Q3	133
95-th percentile	168
Maximum	191
Range	147
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	27.06003941
Coefficient of variation (CV)	0.2323132681
Kurtosis	-0.1212147722
Mean	116.4808176
Median Absolute Deviation (MAD)	17
Skewness	0.5017046811
Sum	73033.47266
Variance	732.2457329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	16	2.5%
125	14	2.2%
106	14	2.2%
100	14	2.2%
112	13	2.0%
95	13	2.0%
102	13	2.0%
111	12	1.9%
108	12	1.9%
107	11	1.7%
Other values (114)	495	77.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44	1	0.2%
56	1	0.2%
57	2	0.3%
61	1	0.2%
62	1	0.2%
65	1	0.2%
67	1	0.2%
68	1	0.2%
71	4	0.6%
72	1	0.2%

Value	Count	Frequency (%)
191	1	0.2%
190	1	0.2%
188	1	0.2%
184	2	0.3%
183	3	0.5%
182	1	0.2%
181	1	0.2%
180	4	0.6%
179	5	0.8%
178	1	0.2%

BloodPressure
Real number (ℝ_≥0)

Distinct	36
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.66356579

Minimum	40
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	40
5-th percentile	54
Q1	64
median	70
Q3	78
95-th percentile	90
Maximum	98
Range	58
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	10.73919965
Coefficient of variation (CV)	0.1498557814
Kurtosis	-0.2040459556
Mean	71.66356579
Median Absolute Deviation (MAD)	8
Skewness	-0.02198672912
Sum	45649.69141
Variance	115.330409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
70	49	7.7%
74	46	7.2%
64	39	6.1%
68	39	6.1%
72	37	5.8%
78	37	5.8%
69.10546875	35	5.5%
80	35	5.5%
76	31	4.9%
60	30	4.7%
Other values (26)	259	40.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40	1	0.2%
44	4	0.6%
46	1	0.2%
48	4	0.6%
50	11	1.7%
52	10	1.6%
54	11	1.7%
55	2	0.3%
56	12	1.9%
58	14	2.2%

Value	Count	Frequency (%)
98	3	0.5%
96	4	0.6%
95	1	0.2%
94	6	0.9%
92	8	1.3%
90	16	2.5%
88	22	3.5%
86	18	2.8%
85	6	0.9%
84	15	2.4%

SkinThickness
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	40
Distinct (%)	6.4%
Missing	12
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	25.01615

Minimum	8
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	8
5-th percentile	15
Q1	20.53645833
median	20.53645833
Q3	30
95-th percentile	41
Maximum	47
Range	39
Interquartile range (IQR)	9.463541667

Descriptive statistics

Standard deviation	7.939049498
Coefficient of variation (CV)	0.3173569673
Kurtosis	-0.09060124681
Mean	25.01615
Median Absolute Deviation (MAD)	3.463541667
Skewness	0.7787363824
Sum	15635.09375
Variance	63.02850692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
20.53645833	222	34.9%
32	25	3.9%
30	24	3.8%
23	19	3.0%
18	19	3.0%
27	18	2.8%
28	18	2.8%
19	17	2.7%
31	15	2.4%
15	14	2.2%
Other values (30)	234	36.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	0.2%
10	4	0.6%
11	6	0.9%
12	6	0.9%
13	8	1.3%
14	4	0.6%
15	14	2.2%
16	5	0.8%
17	11	1.7%
18	19	3.0%

Value	Count	Frequency (%)
47	2	0.3%
46	6	0.9%
45	2	0.3%
44	3	0.5%
43	4	0.6%
42	5	0.8%
41	12	1.9%
40	14	2.2%
39	11	1.7%
38	5	0.8%

Insulin
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	103
Distinct (%)	16.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	89.22733108

Minimum	22
Maximum	180
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	22
5-th percentile	50
Q1	79.79947917
median	79.79947917
Q3	88
95-th percentile	159.2
Maximum	180
Range	158
Interquartile range (IQR)	8.200520833

Descriptive statistics

Standard deviation	29.26401127
Coefficient of variation (CV)	0.3279713841
Kurtosis	1.825112749
Mean	89.22733108
Median Absolute Deviation (MAD)	0
Skewness	1.347334711
Sum	56837.8099
Variance	856.3823557
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79.79947917	365	57.3%
105	11	1.7%
140	8	1.3%
130	8	1.3%
180	7	1.1%
94	7	1.1%
100	7	1.1%
120	7	1.1%
115	6	0.9%
110	6	0.9%
Other values (93)	205	32.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22	1	0.2%
23	2	0.3%
29	1	0.2%
32	1	0.2%
36	3	0.5%
37	2	0.3%
38	1	0.2%
40	2	0.3%
41	1	0.2%
42	1	0.2%

Value	Count	Frequency (%)
180	7	1.1%
178	1	0.2%
176	3	0.5%
175	3	0.5%
171	1	0.2%
170	2	0.3%
168	4	0.6%
167	2	0.3%
166	1	0.2%
165	4	0.6%

BMI
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	220
Distinct (%)	35.0%
Missing	8
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%
Mean	31.4807923

Minimum	18.2
Maximum	46.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	18.2
5-th percentile	21.9
Q1	26.9
median	31.6
Q3	35.4
95-th percentile	42.86
Maximum	46.8
Range	28.6
Interquartile range (IQR)	8.5

Descriptive statistics

Standard deviation	6.122196083
Coefficient of variation (CV)	0.1944740153
Kurtosis	-0.3737853438
Mean	31.4807923
Median Absolute Deviation (MAD)	4.2
Skewness	0.2507719123
Sum	19801.41836
Variance	37.48128488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31.6	11	1.7%
31.99257812	11	1.7%
31.2	10	1.6%
33.3	10	1.6%
32	10	1.6%
32.4	9	1.4%
30.8	8	1.3%
34.2	8	1.3%
29.7	8	1.3%
30	7	1.1%
Other values (210)	537	84.3%
(Missing)	8	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.2	3	0.5%
18.4	1	0.2%
19.1	1	0.2%
19.3	1	0.2%
19.4	1	0.2%
19.5	2	0.3%
19.6	2	0.3%
19.9	1	0.2%
20	1	0.2%
20.4	2	0.3%

Value	Count	Frequency (%)
46.8	2	0.3%
46.7	1	0.2%
46.3	1	0.2%
46.2	1	0.2%
46.1	2	0.3%
45.7	1	0.2%
45.6	1	0.2%
45.5	1	0.2%
45.3	3	0.5%
45.2	1	0.2%

DiabetesPedigreeFunction
Real number (ℝ_≥0)

MISSING

Distinct	435
Distinct (%)	69.6%
Missing	12
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.428736

Minimum	0.078
Maximum	1.353
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	0.078
5-th percentile	0.137
Q1	0.236
median	0.343
Q3	0.582
95-th percentile	0.9538
Maximum	1.353
Range	1.275
Interquartile range (IQR)	0.346

Descriptive statistics

Standard deviation	0.264833497
Coefficient of variation (CV)	0.6177076267
Kurtosis	0.9643082476
Mean	0.428736
Median Absolute Deviation (MAD)	0.147
Skewness	1.164151679
Sum	267.96
Variance	0.07013678115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.268	5	0.8%
0.261	5	0.8%
0.254	5	0.8%
0.258	5	0.8%
0.263	4	0.6%
0.259	4	0.6%
0.238	4	0.6%
0.284	4	0.6%
0.245	4	0.6%
0.304	4	0.6%
Other values (425)	581	91.2%
(Missing)	12	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.078	1	0.2%
0.084	1	0.2%
0.085	2	0.3%
0.088	2	0.3%
0.089	1	0.2%
0.092	1	0.2%
0.096	1	0.2%
0.1	1	0.2%
0.101	1	0.2%
0.102	1	0.2%

Value	Count	Frequency (%)
1.353	1	0.2%
1.321	1	0.2%
1.318	1	0.2%
1.292	1	0.2%
1.282	1	0.2%
1.268	1	0.2%
1.251	1	0.2%
1.224	1	0.2%
1.222	1	0.2%
1.213	1	0.2%

Age
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	44
Distinct (%)	7.1%
Missing	15
Missing (%)	2.4%
Infinite	0
Infinite (%)	0.0%
Mean	32.23311897

Minimum	21
Maximum	64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 KiB

Quantile statistics

Minimum	21
5-th percentile	21
Q1	24
median	28.5
Q3	39
95-th percentile	53.95
Maximum	64
Range	43
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.50674178
Coefficient of variation (CV)	0.3259610647
Kurtosis	0.1708331769
Mean	32.23311897
Median Absolute Deviation (MAD)	6.5
Skewness	0.9962409938
Sum	20049
Variance	110.3916228
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
22	62	9.7%
21	54	8.5%
25	41	6.4%
24	40	6.3%
28	31	4.9%
23	29	4.6%
26	27	4.2%
27	27	4.2%
29	21	3.3%
41	19	3.0%
Other values (34)	271	42.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	54	8.5%
22	62	9.7%
23	29	4.6%
24	40	6.3%
25	41	6.4%
26	27	4.2%
27	27	4.2%
28	31	4.9%
29	21	3.3%
30	17	2.7%

Value	Count	Frequency (%)
64	1	0.2%
63	4	0.6%
62	4	0.6%
61	1	0.2%
60	3	0.5%
59	2	0.3%
58	3	0.5%
57	4	0.6%
56	2	0.3%
55	3	0.5%

Outcome
Categorical

CONSTANT
MISSING
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	203
Missing (%)	31.9%
Memory size	5.1 KiB

0.0	434

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1302
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	434	68.1%
(Missing)	203	31.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	434	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	868	66.7%
.	434	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	868	66.7%
Other Punctuation	434	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	868	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1302	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	868	66.7%
.	434	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1302	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	868	66.7%
.	434	33.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
0	6.0	148.0	72.000000	35.000000	79.799479	33.600000	0.627	50.0	NaN
1	1.0	85.0	66.000000	29.000000	79.799479	26.600000	0.351	31.0	0.0
2	8.0	183.0	64.000000	20.536458	79.799479	23.300000	0.672	32.0	NaN
3	1.0	89.0	66.000000	23.000000	94.000000	28.100000	0.167	21.0	0.0
4	0.0	137.0	40.000000	35.000000	168.000000	43.100000	NaN	33.0	NaN
5	5.0	116.0	74.000000	20.536458	79.799479	25.600000	0.201	30.0	0.0
6	3.0	78.0	50.000000	32.000000	88.000000	31.000000	0.248	26.0	NaN
7	10.0	115.0	69.105469	20.536458	79.799479	35.300000	0.134	29.0	0.0
8	8.0	125.0	96.000000	20.536458	79.799479	31.992578	0.232	54.0	NaN
9	4.0	110.0	92.000000	20.536458	79.799479	37.600000	0.191	30.0	0.0

Last rows

	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome
627	0.0	123.0	72.0	20.536458	79.799479	36.3	0.258	52.0	NaN
628	1.0	106.0	76.0	20.536458	79.799479	37.5	0.197	26.0	0.0
629	6.0	190.0	92.0	20.536458	79.799479	35.5	0.278	NaN	NaN
630	9.0	170.0	74.0	31.000000	79.799479	44.0	0.403	43.0	NaN
631	9.0	89.0	62.0	20.536458	79.799479	22.5	0.142	33.0	0.0
632	10.0	101.0	76.0	NaN	180.000000	32.9	0.171	63.0	0.0
633	2.0	122.0	70.0	27.000000	79.799479	36.8	0.340	27.0	0.0
634	5.0	121.0	72.0	23.000000	112.000000	26.2	0.245	30.0	0.0
635	1.0	126.0	60.0	20.536458	79.799479	30.1	0.349	47.0	NaN
636	1.0	93.0	70.0	31.000000	79.799479	30.4	0.315	23.0	0.0

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows